YAMATO and ASUKA: DNA database management system

Recently, we newly developed a relrrtionrrl schema for eflectively building, integruting. and searching the DNA database on the relational datuhnse mcrnngement system, SYBASE, at DDBJ. The schema is nclmed the “DDBJschema”. The schema uliowed us to implement N DNA database mtmqement system with two types of window inteeaces, YAMATO und ASUKA, to easily build the DNA datcthu.se. The first type with the DDBJ-schemu is utilized by reviawer.v (DDBJ support .stqff:v) for processing N single entry sent by an author. The second type with it is utilized by the Human Genome Project for processing multiple entries. Both also hove c1 window interfuce similar to the flat ,file format. Finally, we developed two udditiontrl systems for both YAMATO cmd ASUKA. One i.s u restructuring tool to convert dclt(l with the GenBnnk-schema into those with the DDBJ-schemri when we move AWB to the new system. Other is N tree secrrch tool needed to repair the existing tlixonom\ dcltabase which is including man!’ kinds of err0r.s. A structured SQL-progrctmming method is proposed to be used to implement these additioncd .systems. The method is developed through the SQL expression and the control flow lrtnguqe (CFL) of SYBASE. trnd allowed us to implement the restructurjng tool cmd the tree search tool.